﻿CREATE TABLE [dbo].[SitePageDefinitions] (
    [Id]                  INT            IDENTITY (1, 1) NOT NULL,
    [InternalName]        NVARCHAR (64)  NOT NULL,
    [InternalDescription] NVARCHAR (128) NULL,
    [IsActive]            BIT            NOT NULL,
    [SitePageGroupId]     INT            NOT NULL,
    CONSTRAINT [PK_PagesDefenitions] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_SitePageDefinition_SitePageDefinition] FOREIGN KEY ([SitePageGroupId]) REFERENCES [dbo].[SitePageGroups] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE
);

